How to: Use CONCATENATE() function to combine contents of multiple cells in one.
Solution:
Select the cell to contain the results; type =CONCATENATE() and specify individually the cells containing contents that need to be joined.
1) Select the cell where the result of the CONCATENATE() function should appear.
2) Type an equal sign and the CONCATENATE command:
=CONCATENATE()
3) Specify individually the cells containing the contents that need to be joined.
EXAMPLE: To join the word 'Monthly' in the cell 'C2' and the word 'Payment' in 'C4' so that it reads 'Monthly Payment' in 'C5', type the following command in 'C5':
=CONCATENATE(C2,'' '',C4)
NOTE: The CONCATENATE() function takes up to 30 items. The items can be numbers, text, or individual cell references as shown in the above example. Note that text, including spaces, must be enclosed in quotation marks.
4) Press ENTER. (Excel displays the result in the selected cell.)
